<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Welcome extends CI_Controller {

	/**
	 * Index Page for this controller.
	 *
	 * Maps to the following URL
	 * 		http://example.com/index.php/welcome
	 *	- or -
	 * 		http://example.com/index.php/welcome/index
	 *	- or -
	 * Since this controller is set as the default controller in
	 * config/routes.php, it's displayed at http://example.com/
	 *
	 * So any other public methods not prefixed with an underscore will
	 * map to /index.php/welcome/<method_name>
	 * @see http://codeigniter.com/user_guide/general/urls.html
	 */
	public function index()
	{
		$this->dbConnectsql = $this->load->database("sqlserver",TRUE);
         //$res_dataone = $this->Data_model->get_single_data(array("UserId" => "B3DB39DC-16D1-4500-92BE-0755FB2F255D"),"aspnet_Membership");
         $query = $this->dbConnectsql->query("SELECT * FROM aspnet_Membership where UserId='B3DB39DC-16D1-4500-92BE-0755FB2F255D'");
         $res_dataone = $query->row_array();
         var_dump($res_dataone);
	}
}
